Can't get over this error, and net searches reveal other postings similiar, but no answers. SSIS database transfer task (with overwrite) from SQL 2k source to SQL 2k5 destination fails with: Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE ROLE [RFRSH_USER] " failed with the following error: "User, group, or role 'RFRSH_USER' already exists in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter. The error seems the same regardless if the destination DB exists or not! Anyone have a solution?

Mee 2! Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=0 description=Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter. We need to get some Microsoft guys answer this. Best, d.

Hello Icemania, I was wondering if you got a solution to this problem. I also am having the same problem. Like you said, it does not matter if you are doing an overwrite or creating a new database with the transfer. I have tried several databases with the same results. Not sure how to get around this. Can usually find a solution in Google, but not this time. Thanks, Wesman

Does any one has an answer to this yet? I am having the same issue... The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE ROLE [exec_role]" failed with the following error: "User, group, or role 'exec_role' already exists in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Thanks

A_M, MS reported that the issue should have been fixed with the 2005 SP2- but my tests so far still seem to have the same problem. Sorry!

Icemandia wrote: A_M, MS reported that the issue should have been fixed with the 2005 SP2- but my tests so far still seem to have the same problem. Sorry!My understanding is that sp2 is still in beta. Therefore, it is not yet complete.

The fix is available in SP2 CTP2.

Do you have a link to download that? what is CTP by the way?

Pelucon wrote: Do you have a link to download that? http://msdn.microsoft.com/en-us/sqlserver/bb895958.aspx what is CTP by the way? "ctp" means "community technology preview"...which is just a euphemism for "beta".

Hi, This still doesn't work for me. I have downloaded SQL 2005 SP3 on both the server and on the client machine. Is there another fix? Thanks ChrisTKE402

Hi I have tried this with SQL 2008 R2 and I get the same result. Can someone help. Could it be that I am copying a DB from a SQL2000 server? Thanks TKE402